# -*- coding: utf-8 -*-


import openpyxl

excel_1 = openpyxl.load_workbook('test.xlsx')      # 可以当作字典索引，键为表名，值为工作表


sheet = excel_1[excel_1.sheetnames[0]]

row1 = sheet[1]
row2 = sheet[2]
row3 = sheet[3]
row4 = sheet[4]



xxx = row1[1:] + row3[1:]


print([x.value for x in xxx])


